<html>

<head>
    <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js" type="text/javascript"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            $("#export").click(function (e) {
                e.preventDefault();

                //getting data from our table
                var data_type = 'data:application/vnd.ms-excel';
                var table_div = document.getElementById('report_table');
                var table_html = table_div.outerHTML.replace(/ /g, '%20');

                var a = document.createElement('a');
                a.href = data_type + ', ' + table_html;
                a.download = 'Basic Information Report.xls';
                a.click();
            });
        });

        var submit = function () {

            var month, subproject, district;
            var getMonth = function (a) {
                if (a == "1" || a == "01") { month = "January" }
                if (a == "2" || a == "02") { month = "February" }
                if (a == "3" || a == "03") { month = "March" }
                if (a == "4" || a == "04") { month = "April" }
                if (a == "5" || a == "05") { month = "May" }
                if (a == "6" || a == "06") { month = "June" }
                if (a == "7" || a == "07") { month = "July" }
                if (a == "8" || a == "08") { month = "August" }
                if (a == "9" || a == "09") { month = "September" }
                if (a == "10") { month = "october" }
                if (a == "11") { month = "November" }
                if (a == "12") { month = "December" }
                return month;
            };
            var json = "";
            var checkOuLevel = function (ou) {
                $.ajax({
                    async: false,
                    type: "GET",
                    url: "../api/organisationUnits/" + ou + ".json",
                    success: function (data) {
                        json = data;

                    }
                });
                return json;
            };


            var getDistrict = function (ou) {
                $.ajax({
                    async: false,
                    type: "GET",
                    url: "../api/organisationUnits/" + ou + ".json?fields=ancestors[id,name,level]",
                    success: function (data) {
                        for (var i = 0; i < data.ancestors.length; i++) {
                            if (data.ancestors[i].level == 2) {
                                district = data.ancestors[i].name;
                            }
                        }

                    }
                });
                return district;
            };

            var getPeriodArray = function (sm, em) {
                var array = "";
                sm = parseInt(sm);
                em = parseInt(em);
                //   var pem = em;
                while (em != sm || em > sm) {
                    if (em == 201700) {
                        em = 201612;
                    }
                    if (em == 201800) {
                        em = 201712;
                    }
                    if (em == 201600) {
                        em = 201512;
                    }
                    if (em == 201500) {
                        em = 201412;
                    }
                    if (em == 201500) {
                        em = 201412;
                    }
                    if (em == 201400) {
                        em = 201312;
                    }
                    if (em == 201300) {
                        em = 201212;
                    }
                    if (em == 201200) {
                        em = 201112;
                    }
                    if (em == 201100) {
                        em = 201012;
                    }
                    if (em == 201000) {
                        em = 200912;
                    }
                    if (em == 200900) {
                        em = 200812;
                    }
                    if (em == 200800) {
                        em = 200712;
                    }
                    if (em == 200700) {
                        em = 200612;
                    }
                    array = array + em + ";";
                    em -= 1;

                }
                //    array = array + ouPe;
                return array;
            };

            var url = window.location.href;
            // var pe1 = url.split("&")[1];
            // var pe = pe1.split("=")[1];

            var startDat = document.getElementById("start").value;
            var endDat = document.getElementById("end").value;
            document.getElementById('periodFrom').innerHTML = startDat;
            document.getElementById('periodTo').innerHTML = endDat;
            var s = startDat.split('-');
            var ss = s.join('');
            var startmonth = ss.substr(0, 6);
            var e = endDat.split('-');
            var ee = e.join('');
            var endmonth = ee.substr(0, 6);
            var initialmonth = "200701";
            var periodArr1 = getPeriodArray(initialmonth, startmonth);
            var periodArr2 = getPeriodArray(startmonth, endmonth);
            var periodArr3 = getPeriodArray(initialmonth, endmonth);
            var monthCode = startmonth.substr(4, 6);
            var monthCode2 = endmonth.substr(4, 6);
            var monthname = getMonth(monthCode);
            var monthname2 = getMonth(monthCode);
            var year = startmonth.substr(0, 4);
            var year2 = endmonth.substr(0, 4);
            document.getElementById('timePeriod').innerHTML = monthname + " " + year + " to " + monthname2 + " " + year2;
            var ou1 = url.split("&")[1];
            var ou = ou1.split("=")[1];
            var ouLeveldata = checkOuLevel(ou);
            var ouLevel = ouLeveldata.level;
            document.getElementById('ouname').innerHTML = ouLeveldata.displayName;

            var br1col1 = 0, br1col2 = 0, br1col3 = 0, br1col4 = 0, br1col5 = 0, br1col6 = 0, br1col7 = 0, br1col8 = 0, br1col9 = 0, br1col10 = 0, br1col11 = 0, br1col12 = 0, br1col13 = 0, br1col14 = 0;

            var dr1col1 = 0, dr1col2 = 0, dr1col4 = 0, dr1col5 = 0, dr1col6 = 0, dr1col7 = 0, dr1col8 = 0, dr1col9 = 0, dr1col10 = 0, dr1col11 = 0, dr1col3 = 0, dr1col12 = 0, dr1col13 = 0, dr1col14 = 0;

            var dr2col1 = 0, dr2col2 = 0, dr2col3 = 0, dr2col4 = 0, dr2col5 = 0, dr2col6 = 0, dr2col7 = 0, dr2col8 = 0, dr2col9 = 0, dr2col10 = 0, dr2col11 = 0, dr2col12 = 0, dr2col13 = 0, dr2col14 = 0;

            var er1col1 = 0, er1col2 = 0, er1col3 = 0, er1col4 = 0, er1col5 = 0, er1col6 = 0, er1col7 = 0, er1col8 = 0, er1col9 = 0, er1col10 = 0, er1col11 = 0, er1col12 = 0, er1col13 = 0, er1col14 = 0;

            var er2col1 = 0, er2col2 = 0, er2col3 = 0, er2col4 = 0, er2col5 = 0, er2col6 = 0, er2col7 = 0, er2col8 = 0, er2col9 = 0, er2col10 = 0, er2col11 = 0, er2col12 = 0, er2col13 = 0, er2col14 = 0;

            var er3col1 = 0, er3col2 = 0, er3col3 = 0, er3col4 = 0, er3col5 = 0, er3col6 = 0, er3col7 = 0, er3col8 = 0, er3col9 = 0, er3col10 = 0, er3col11 = 0, er3col12 = 0, er3col13 = 0, er3col14 = 0;

            var er4col1 = 0, er4col2 = 0, er4col3 = 0, er4col4 = 0, er4col5 = 0, er4col6 = 0, er4col7 = 0, er4col8 = 0, er4col9 = 0, er4col10 = 0, er4col11 = 0, er4col12 = 0, er4col13 = 0, er4col14 = 0;

            var er5col1 = 0, er5col2 = 0, er5col3 = 0, er5col4 = 0, er5col5 = 0, er5col6 = 0, er5col7 = 0, er5col8 = 0, er5col9 = 0, er5col10 = 0, er5col11 = 0, er5col12 = 0, er5col13 = 0, er5col14 = 0;

            var br2col1 = 0, br2col2 = 0, br2col3 = 0, br2col4 = 0, br2col5 = 0, br2col6 = 0, br2col7 = 0, br2col8 = 0, br2col9 = 0, br2col10 = 0, br2col11 = 0, br2col12 = 0, br2col13 = 0, br2col14 = 0;

            var dr3col1 = 0, dr3col2 = 0, dr3col4 = 0, dr3col5 = 0, dr3col6 = 0, dr3col7 = 0, dr3col8 = 0, dr3col9 = 0, dr3col10 = 0, dr3col11 = 0, dr3col3 = 0, dr3col12 = 0, dr3col13 = 0, dr3col14 = 0;

            var dr4col1 = 0, dr4col2 = 0, dr4col4 = 0, dr4col5 = 0, dr4col6 = 0, dr4col7 = 0, dr4col8 = 0, dr4col9 = 0, dr4col10 = 0, dr4col11 = 0, dr4col3 = 0, dr4col12 = 0, dr4col13 = 0, dr4col14 = 0;

            var dr5col1 = 0, dr5col2 = 0, dr5col4 = 0, dr5col5 = 0, dr5col6 = 0, dr5col7 = 0, dr5col8 = 0, dr5col9 = 0, dr5col10 = 0, dr5col11 = 0, dr5col3 = 0, dr5col12 = 0, dr5col13 = 0, dr5col14 = 0;

            var er6col1 = 0, er6col2 = 0, er6col3 = 0, er6col4 = 0, er6col5 = 0, er6col6 = 0, er6col7 = 0, er6col8 = 0, er6col9 = 0, er6col10 = 0, er6col11 = 0, er6col12 = 0, er6col13 = 0, er6col14 = 0;

            var er7col1 = 0, er7col2 = 0, er7col3 = 0, er7col4 = 0, er7col5 = 0, er7col6 = 0, er7col7 = 0, er7col8 = 0, er7col9 = 0, er7col10 = 0, er7col11 = 0, er7col12 = 0, er7col13 = 0, er7col14 = 0;

            var er8col1 = 0, er8col2 = 0, er8col3 = 0, er8col4 = 0, er8col5 = 0, er8col6 = 0, er8col7 = 0, er8col8 = 0, er8col9 = 0, er8col10 = 0, er8col11 = 0, er8col12 = 0, er8col13 = 0, er8col14 = 0;

            var er9col1 = 0, er9col2 = 0, er9col3 = 0, er9col4 = 0, er9col5 = 0, er9col6 = 0, er9col7 = 0, er9col8 = 0, er9col9 = 0, er9col10 = 0, er9col11 = 0, er9col12 = 0, er9col13 = 0, er9col14 = 0;

            var er10col1 = 0, er10col2 = 0, er10col3 = 0, er10col4 = 0, er10col5 = 0, er10col6 = 0, er10col7 = 0, er10col8 = 0, er10col9 = 0, er10col10 = 0, er10col11 = 0, er10col12 = 0, er10col13 = 0, er10col14 = 0;

            var er11col1 = 0, er11col2 = 0, er11col3 = 0, er11col4 = 0, er11col5 = 0, er11col6 = 0, er11col7 = 0, er11col8 = 0, er11col9 = 0, er11col10 = 0, er11col11 = 0, er11col12 = 0, er11col13 = 0, er11col14 = 0;

            var er12col1 = 0, er12col2 = 0, er12col3 = 0, er12col4 = 0, er12col5 = 0, er12col6 = 0, er12col7 = 0, er12col8 = 0, er12col9 = 0, er12col10 = 0, er12col11 = 0, er12col12 = 0, er12col13 = 0, er12col14 = 0;

            var er13col1 = 0, er13col2 = 0, er13col3 = 0, er13col4 = 0, er13col5 = 0, er13col6 = 0, er13col7 = 0, er13col8 = 0, er13col9 = 0, er13col10 = 0, er13col11 = 0, er13col12 = 0, er13col13 = 0, er13col14 = 0;

            var er14col1 = 0, er14col2 = 0, er14col3 = 0, er14col4 = 0, er14col5 = 0, er14col6 = 0, er14col7 = 0, er14col8 = 0, er14col9 = 0, er14col10 = 0, er14col11 = 0, er14col12 = 0, er14col13 = 0, er14col14 = 0;

            var er15col1 = 0, er15col2 = 0, er15col3 = 0, er15col4 = 0, er15col5 = 0, er15col6 = 0, er15col7 = 0, er15col8 = 0, er15col9 = 0, er15col10 = 0, er15col11 = 0, er15col12 = 0, er15col13 = 0, er15col14 = 0;


            var printData = function (ouu) {

                $.ajax({
                    async: false,
                    type: "GET",
                    url: "../api/26/analytics.json?dimension=ou:" + ou + "&dimension=dx:lgG7sLJHkXD;KLVwlGbPfrd;oQsOFcLWr16;M2UqS9yPvmf;ljwLmM6wr9Q;KNKg61BuEMy;zErmC4XNghY;Z1eO1TqGNUA;oiiYR7c34Fv;R08yh7oQu9u;lSyNrWYfDsr;XTaEEkVcb1U;FbdvhdkfCPe;rcmpCvr2RiS;pVrTymZPjsS;YcRbodEBwz7;J7LAfW3W4Se;Wzt8bX2uuSS;eCizndeOgOL;kL2ZzQB22el;sko4wrDIBrG;G39eK1FSOIK;fnMCbjHPPlH;LFr7AhbrSe0;ILD8xBt3SOg;BERQTbfCeSD;dcvSAZL9jwL;j4RgAVukHqt;BB4lsloruCO;nQuxGC2obpp;LQUW2emTZjO;cPVoP9eBnRi;nDysWwAKdrI;RrvQm5mVJjr;BouHGzciVwt;ZAiWWRfqmtq;RGy4bq5ln8H;t6OmlTSCMcc;YGUoF05LbTj;BMhVhZQdQjJ;o3y6PPKOAWa;SxWbqQI7tql;TIvoqYe1iag;iLUovFDBCIS;t7n7DDcETxd;bF8eKecG4Pz;kq2v323r7vD;m9ThAiXNylV;b9m0DLFUSEK;OTMxo4igghE;TeGJ1EmTLi0;nFWZuyFlErh;t0cylQ32bVj;JoYomZyo7wJ;JKkV7GfIDiS;fr5atUTVfVj;LwS5oL5OGHz;tEillAIY6zj;riAbakYbbjO;CWRlue6ZHCg;wqNur5grWMD;GP5Sx0wSS99;eaaA3O7cQSR;oMUMcDIfJMh;K3jvC9Z4JVh;DL449Nedrxo;bCVen8l0fPP;NkgnGtwFHdc;DMvphqfUqyK;LraRv6zBiMj;BhzfuZWcQ0D;bQjg7Dx8dko;llvLu3s0Hho;KnNFacB9vmA;m8mS7H28VAQ;aCoc1c9mvLM;LVWx9Yon73S;MMGKRwqwux1;aqxczPhPYIl;LiRRVvsoIkE;dm7bgPcMmTA;N30mCFhM6WC;BZc1ECoag5l;FV5VCAz6VuI;OLbzri3COhr;GRLuyIWM0Fr;CJsQy4WWSa8;wCzU8dz6khS;PpsyxjQyUmU;Cd3U6BoNOcv;hi4qW0FIEfP;ATAA0lYRa9X;ky7biRERNzN;jET16btk8U3;OGhyxH6RBKi;OAQnYRhbdPC;N2eyreJFV0k;uM1fMxbvQ63;DQl5AYqKjEq;tQrJebVU7QR;FnKZNfqMKKJ;kguQUVMTPd9;EdAdQi0gbG8;xyww91ohFgL;Ezoj5xEOw0F;QdSPjMji93R;XOgcwiLlyrv;j5qhUGPrbgf;kd9Z427lPL2;KKV0Q6HrKuX;LvsGdrQCRWl;yYmx0rygvEP;l5rfkS2n12P;vsH2eBgHLhI;YR9UNXUwzSw;URJfaEOMmUv;witjd0ZffDY;P7vkW2W4EoR;eV3AFlVfaLU;GLGjY4wD2Mt;DV8SDPpAAnm;Il3PSDi4L4O;yOXdjjFlXSV;KS11snhthiJ;Xp38tiz1LRy;Cc9YL1VCoc5;ONynbaSGjdr;k24y1rGDfa0;qk8jFUNefxr;FTWHNxT4Bt7;ois8gqsgQOp;e9ismzP8RNk;mCfuMjRIeQH;NA1wBvJUYyj;by0DEh24K9I;Ox5DywdZ9bu;J2gQji3PI45;jf37qAe4U0a;RHviq52c4CX;aCNU5DCCfWd&filter=pe:" + periodArr1 + "&displayProperty=NAME&outputIdScheme=NAME",
                    success: function (data1) {


                        for (var i = 0; i < data1.rows.length; i++) {
                            if (data1.rows[i][0] == "Patients enrolled in HIV care (female)_HMIS 9.3") {
                                br1col1 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "Patients enrolled in HIV care (male)_HMIS 9.3") {
                                br1col2 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "Patients enrolled in HIV care (other sex)_HMIS 9.3") {
                                br1col3 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "Patients enrolled in HIV care (female, < 1 yrs)_HMIS 9.3") {
                                br1col4 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "Patients enrolled in HIV care (female, 1-4 yrs)_HMIS 9.3") {
                                br1col5 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "Patients enrolled in HIV care (female, 5-14 yrs)_HMIS 9.3") {
                                br1col6 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "Patients enrolled in HIV care (male, < 1 yrs)_HMIS 9.3") {
                                br1col7 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "Patients enrolled in HIV care (male, 1-4 yrs)_HMIS 9.3") {
                                br1col8 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "Patients enrolled in HIV care (male, 5-14 yrs)_HMIS 9.3") {
                                br1col9 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "Patients enrolled in HIV care (sex worker)_HMIS 9.3") {
                                br1col10 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "Patients enrolled in HIV care (people who inject drugs)_HMIS 9.3") {
                                br1col11 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "Patients enrolled in HIV care (MSM/TG)_HMIS 9.3") {
                                br1col12 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "Patients enrolled in HIV care (migrants)_HMIS 9.3") {
                                br1col13 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "Patients enrolled in HIV care (others)_HMIS 9.3") {
                                br1col14 += parseInt(data1.rows[i][2]);
                            }

                            //row 9
                            if (data1.rows[i][0] == "ART treatment initiated (female)_HMIS 9.3") {
                                br2col1 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "ART treatment initiated (male)_HMIS 9.3") {
                                br2col2 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "ART treatment initiated (other sex)_HMIS 9.3") {
                                br2col3 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "ART treatment initiated (female, < 1 yrs)_HMIS 9.3") {
                                br2col4 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "ART treatment initiated (female, 1-4 yrs)_HMIS 9.3") {
                                br2col5 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "ART treatment initiated (female, 5-14 yrs)_HMIS 9.3") {
                                br2col6 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "ART treatment initiated (male, < 1 yrs)_HMIS 9.3") {
                                br2col7 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "ART treatment initiated (male, 1-4 yrs)_HMIS 9.3") {
                                br2col8 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "ART treatment initiated (male, 5-14 yrs)_HMIS 9.3") {
                                br2col9 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "ART treatment initiated (sex worker)_HMIS 9.3") {
                                br2col10 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "ART treatment initiated (people who inject drugs)_HMIS 9.3") {
                                br2col11 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "ART treatment initiated (MSM/TG)_HMIS 9.3") {
                                br2col12 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "ART treatment initiated (migrants)_HMIS 9.3") {
                                br2col13 += parseInt(data1.rows[i][2]);
                            }
                            if (data1.rows[i][0] == "ART treatment initiated (others)_HMIS 9.3") {
                                br2col14 += parseInt(data1.rows[i][2]);
                            }
                        }

                        $.ajax({
                            async: false,
                            type: "GET",
                            url: "../api/26/analytics.json?dimension=ou:" + ou + "&dimension=dx:lgG7sLJHkXD;KLVwlGbPfrd;oQsOFcLWr16;M2UqS9yPvmf;ljwLmM6wr9Q;KNKg61BuEMy;zErmC4XNghY;Z1eO1TqGNUA;oiiYR7c34Fv;R08yh7oQu9u;lSyNrWYfDsr;XTaEEkVcb1U;FbdvhdkfCPe;rcmpCvr2RiS;pVrTymZPjsS;YcRbodEBwz7;J7LAfW3W4Se;Wzt8bX2uuSS;eCizndeOgOL;kL2ZzQB22el;sko4wrDIBrG;G39eK1FSOIK;fnMCbjHPPlH;LFr7AhbrSe0;ILD8xBt3SOg;BERQTbfCeSD;dcvSAZL9jwL;j4RgAVukHqt;BB4lsloruCO;nQuxGC2obpp;LQUW2emTZjO;cPVoP9eBnRi;nDysWwAKdrI;RrvQm5mVJjr;BouHGzciVwt;ZAiWWRfqmtq;RGy4bq5ln8H;t6OmlTSCMcc;YGUoF05LbTj;BMhVhZQdQjJ;o3y6PPKOAWa;SxWbqQI7tql;TIvoqYe1iag;iLUovFDBCIS;t7n7DDcETxd;bF8eKecG4Pz;kq2v323r7vD;m9ThAiXNylV;b9m0DLFUSEK;OTMxo4igghE;TeGJ1EmTLi0;nFWZuyFlErh;t0cylQ32bVj;JoYomZyo7wJ;JKkV7GfIDiS;fr5atUTVfVj;LwS5oL5OGHz;tEillAIY6zj;riAbakYbbjO;CWRlue6ZHCg;wqNur5grWMD;GP5Sx0wSS99;eaaA3O7cQSR;oMUMcDIfJMh;K3jvC9Z4JVh;DL449Nedrxo;bCVen8l0fPP;NkgnGtwFHdc;DMvphqfUqyK;LraRv6zBiMj;BhzfuZWcQ0D;bQjg7Dx8dko;llvLu3s0Hho;KnNFacB9vmA;m8mS7H28VAQ;aCoc1c9mvLM;LVWx9Yon73S;MMGKRwqwux1;aqxczPhPYIl;LiRRVvsoIkE;dm7bgPcMmTA;N30mCFhM6WC;BZc1ECoag5l;FV5VCAz6VuI;OLbzri3COhr;GRLuyIWM0Fr;CJsQy4WWSa8;wCzU8dz6khS;PpsyxjQyUmU;Cd3U6BoNOcv;hi4qW0FIEfP;ATAA0lYRa9X;ky7biRERNzN;jET16btk8U3;OGhyxH6RBKi;OAQnYRhbdPC;N2eyreJFV0k;uM1fMxbvQ63;DQl5AYqKjEq;tQrJebVU7QR;FnKZNfqMKKJ;kguQUVMTPd9;EdAdQi0gbG8;xyww91ohFgL;Ezoj5xEOw0F;QdSPjMji93R;XOgcwiLlyrv;j5qhUGPrbgf;kd9Z427lPL2;KKV0Q6HrKuX;LvsGdrQCRWl;yYmx0rygvEP;l5rfkS2n12P;vsH2eBgHLhI;YR9UNXUwzSw;URJfaEOMmUv;witjd0ZffDY;P7vkW2W4EoR;eV3AFlVfaLU;GLGjY4wD2Mt;DV8SDPpAAnm;Il3PSDi4L4O;yOXdjjFlXSV;KS11snhthiJ;Xp38tiz1LRy;Cc9YL1VCoc5;ONynbaSGjdr;k24y1rGDfa0;qk8jFUNefxr;FTWHNxT4Bt7;ois8gqsgQOp;e9ismzP8RNk;mCfuMjRIeQH;NA1wBvJUYyj;by0DEh24K9I;Ox5DywdZ9bu;J2gQji3PI45&filter=pe:" + periodArr2 + "&displayProperty=NAME&outputIdScheme=NAME",
                            success: function (data2) {


                                for (var i = 0; i < data2.rows.length; i++) {
                                    if (data2.rows[i][0] == "Patients enrolled in HIV care (female)_HMIS 9.3") {
                                        dr1col1 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "Patients enrolled in HIV care (male)_HMIS 9.3") {
                                        dr1col2 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "Patients enrolled in HIV care (other sex)_HMIS 9.3") {
                                        dr1col3 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "Patients enrolled in HIV care (female, < 1 yrs)_HMIS 9.3") {
                                        dr1col4 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "Patients enrolled in HIV care (female, 1-4 yrs)_HMIS 9.3") {
                                        dr1col5 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "Patients enrolled in HIV care (female, 5-14 yrs)_HMIS 9.3") {
                                        dr1col6 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "Patients enrolled in HIV care (male, < 1 yrs)_HMIS 9.3") {
                                        dr1col7 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "Patients enrolled in HIV care (male, 1-4 yrs)_HMIS 9.3") {
                                        dr1col8 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "Patients enrolled in HIV care (male, 5-14 yrs)_HMIS 9.3") {
                                        dr1col9 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "Patients enrolled in HIV care (sex worker)_HMIS 9.3") {
                                        dr1col10 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "Patients enrolled in HIV care (people who inject drugs)_HMIS 9.3") {
                                        dr1col11 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "Patients enrolled in HIV care (MSM/TG)_HMIS 9.3") {
                                        dr1col12 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "Patients enrolled in HIV care (migrants)_HMIS 9.3") {
                                        dr1col13 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "Patients enrolled in HIV care (others)_HMIS 9.3") {
                                        dr1col14 += parseInt(data2.rows[i][2]);
                                    }

                                    //row 10
                                    if (data2.rows[i][0] == "ART treatment initiated (female)_HMIS 9.3") {
                                        dr3col1 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "ART treatment initiated (male)_HMIS 9.3") {
                                        dr3col2 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "ART treatment initiated (other sex)_HMIS 9.3") {
                                        dr3col3 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "ART treatment initiated (female, < 1 yrs)_HMIS 9.3") {
                                        dr3col4 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "ART treatment initiated (female, 1-4 yrs)_HMIS 9.3") {
                                        dr3col5 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "ART treatment initiated (female, 5-14 yrs)_HMIS 9.3") {
                                        dr3col6 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "ART treatment initiated (male, < 1 yrs)_HMIS 9.3") {
                                        dr3col7 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "ART treatment initiated (male, 1-4 yrs)_HMIS 9.3") {
                                        dr3col8 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "ART treatment initiated (male, 5-14 yrs)_HMIS 9.3") {
                                        dr3col9 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "ART treatment initiated (sex worker)_HMIS 9.3") {
                                        dr3col10 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "ART treatment initiated (people who inject drugs)_HMIS 9.3") {
                                        dr3col11 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "ART treatment initiated (MSM/TG)_HMIS 9.3") {
                                        dr3col12 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "ART treatment initiated (migrants)_HMIS 9.3") {
                                        dr3col13 += parseInt(data2.rows[i][2]);
                                    }
                                    if (data2.rows[i][0] == "ART treatment initiated (others)_HMIS 9.3") {
                                        dr3col14 += parseInt(data2.rows[i][2]);
                                    }
                                }

                                $.ajax({
                                    async: false,
                                    type: "GET",
                                    url: "../api/26/analytics.json?dimension=ou:" + ou + "&dimension=dx:lgG7sLJHkXD;KLVwlGbPfrd;oQsOFcLWr16;M2UqS9yPvmf;ljwLmM6wr9Q;KNKg61BuEMy;zErmC4XNghY;Z1eO1TqGNUA;oiiYR7c34Fv;R08yh7oQu9u;lSyNrWYfDsr;XTaEEkVcb1U;FbdvhdkfCPe;rcmpCvr2RiS;pVrTymZPjsS;YcRbodEBwz7;J7LAfW3W4Se;Wzt8bX2uuSS;eCizndeOgOL;kL2ZzQB22el;sko4wrDIBrG;G39eK1FSOIK;fnMCbjHPPlH;LFr7AhbrSe0;ILD8xBt3SOg;BERQTbfCeSD;dcvSAZL9jwL;j4RgAVukHqt;BB4lsloruCO;nQuxGC2obpp;LQUW2emTZjO;cPVoP9eBnRi;nDysWwAKdrI;RrvQm5mVJjr;BouHGzciVwt;ZAiWWRfqmtq;RGy4bq5ln8H;t6OmlTSCMcc;YGUoF05LbTj;BMhVhZQdQjJ;o3y6PPKOAWa;SxWbqQI7tql;TIvoqYe1iag;iLUovFDBCIS;t7n7DDcETxd;bF8eKecG4Pz;kq2v323r7vD;m9ThAiXNylV;b9m0DLFUSEK;OTMxo4igghE;TeGJ1EmTLi0;nFWZuyFlErh;t0cylQ32bVj;JoYomZyo7wJ;JKkV7GfIDiS;fr5atUTVfVj;LwS5oL5OGHz;tEillAIY6zj;riAbakYbbjO;CWRlue6ZHCg;wqNur5grWMD;GP5Sx0wSS99;eaaA3O7cQSR;oMUMcDIfJMh;K3jvC9Z4JVh;DL449Nedrxo;bCVen8l0fPP;NkgnGtwFHdc;DMvphqfUqyK;LraRv6zBiMj;BhzfuZWcQ0D;bQjg7Dx8dko;llvLu3s0Hho;KnNFacB9vmA;m8mS7H28VAQ;aCoc1c9mvLM;LVWx9Yon73S;MMGKRwqwux1;aqxczPhPYIl;LiRRVvsoIkE;dm7bgPcMmTA;N30mCFhM6WC;BZc1ECoag5l;FV5VCAz6VuI;OLbzri3COhr;GRLuyIWM0Fr;CJsQy4WWSa8;wCzU8dz6khS;PpsyxjQyUmU;Cd3U6BoNOcv;hi4qW0FIEfP;ATAA0lYRa9X;ky7biRERNzN;jET16btk8U3;OGhyxH6RBKi;OAQnYRhbdPC;N2eyreJFV0k;uM1fMxbvQ63;DQl5AYqKjEq;tQrJebVU7QR;FnKZNfqMKKJ;kguQUVMTPd9;EdAdQi0gbG8;xyww91ohFgL;Ezoj5xEOw0F;QdSPjMji93R;XOgcwiLlyrv;j5qhUGPrbgf;kd9Z427lPL2;KKV0Q6HrKuX;LvsGdrQCRWl;yYmx0rygvEP;l5rfkS2n12P;vsH2eBgHLhI;YR9UNXUwzSw;URJfaEOMmUv;witjd0ZffDY;P7vkW2W4EoR;eV3AFlVfaLU;GLGjY4wD2Mt;DV8SDPpAAnm;Il3PSDi4L4O;yOXdjjFlXSV;KS11snhthiJ;Xp38tiz1LRy;Cc9YL1VCoc5;ONynbaSGjdr;k24y1rGDfa0;qk8jFUNefxr;FTWHNxT4Bt7;ois8gqsgQOp;e9ismzP8RNk;mCfuMjRIeQH;NA1wBvJUYyj;by0DEh24K9I;Ox5DywdZ9bu;J2gQji3PI45&filter=pe:" + periodArr3 + "&displayProperty=NAME&outputIdScheme=NAME",
                                    success: function (data3) {
                                        for (var i = 0; i < data3.rows.length; i++) {

                                            //row 5
                                            if (data3.rows[i][0] == "Patients transferred out (female)_HMIS 9.3") {
                                                er2col1 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients transferred out (male)_HMIS 9.3") {
                                                er2col2 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients transferred out (other sex)_HMIS 9.3") {
                                                er2col3 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients transferred out (female, < 1 yrs)_HMIS 9.3") {
                                                er2col4 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients transferred out (child, female, 1-4 yrs)_HMIS 9.3") {
                                                er2col5 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients transferred out (female, 5-14 yrs)_HMIS 9.3") {
                                                er2col6 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients transferred out (male, < 1 yrs)_HMIS 9.3") {
                                                er2col7 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients transferred out (male, 1-4 yrs)_HMIS 9.3") {
                                                er2col8 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients transferred out (male, 5-14 yrs)_HMIS 9.3") {
                                                er2col9 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients transferred out (sex worker)_HMIS 9.3") {
                                                er2col10 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients transferred out (people who inject drugs)_HMIS 9.3") {
                                                er2col11 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients transferred out (MSM/TG)_HMIS 9.3") {
                                                er2col12 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients transferred out (migrants)_HMIS 9.3") {
                                                er2col13 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients transferred out (other risk groups)_HMIS 9.3") {
                                                er2col14 += parseInt(data3.rows[i][2]);
                                            }

                                            //row 6
                                            if (data3.rows[i][0] == "Patients deceased (female)_HMIS 9.3") {
                                                er3col1 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients deceased (male)_HMIS 9.3") {
                                                er3col2 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients deceased (other sex)_HMIS 9.3") {
                                                er3col3 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients deceased (female, < 1 yrs)_HMIS 9.3") {
                                                er3col4 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients deceased (female, 1-4 yrs)_HMIS 9.3") {
                                                er3col5 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients deceased (female, 5-14 yrs)_HMIS 9.3") {
                                                er3col6 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients deceased (male, < 1 yrs)_HMIS 9.3") {
                                                er3col7 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients deceased (male, 1-4 yrs)_HMIS 9.3") {
                                                er3col8 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients deceased (male, 5-14 yrs)_HMIS 9.3") {
                                                er3col9 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients deceased (sex worker)_HMIS 9.3") {
                                                er3col10 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients deceased (people who inject drugs)_HMIS 9.3") {
                                                er3col11 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients deceased (MSM/TG)_HMIS 9.3") {
                                                er3col12 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients deceased (migrants)_HMIS 9.3") {
                                                er3col13 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients deceased (others)_HMIS 9.3") {
                                                er3col14 += parseInt(data3.rows[i][2]);
                                            }

                                            //row 15
                                            if (data3.rows[i][0] == "Patients missing (female)_HMIS 9.3") {
                                                er9col1 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients missing (male)_HMIS 9.3") {
                                                er9col2 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients missing (other sex)_HMIS 9.3") {
                                                er9col3 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients missing (female, < 1 yrs)_HMIS 9.3") {
                                                er9col4 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients missing (female, 1-4 yrs)_HMIS 9.3") {
                                                er9col5 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients missing (female, 5-14 yrs)_HMIS 9.3") {
                                                er9col6 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients missing (male, < 1 yrs)_HMIS 9.3") {
                                                er9col7 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients missing (male, 1-4 yrs)_HMIS 9.3") {
                                                er9col8 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients missing (male, 5-14 yrs)_HMIS 9.3	") {
                                                er9col9 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients missing (sex worker)_HMIS 9.3") {
                                                er9col10 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients missing (people who inject drugs)_HMIS 9.3") {
                                                er9col11 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients missing (MSM/TG)_HMIS 9.3	") {
                                                er9col12 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients missing (migrants)_HMIS 9.3") {
                                                er9col13 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients missing (other risk groups)_HMIS 9.3") {
                                                er9col14 += parseInt(data3.rows[i][2]);
                                            }

                                            //row 16
                                            if (data3.rows[i][0] == "Patients lost to follow-up (female)_HMIS 9.3") {
                                                er10col1 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients lost to follow-up (male)_HMIS 9.3") {
                                                er10col2 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients lost to follow-up (other sex)_HMIS 9.3") {
                                                er10col3 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients lost to follow-up (female, < 1 yrs)_HMIS 9.3") {
                                                er10col4 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients lost to follow-up (female, 1-4 yrs)_HMIS 9.3") {
                                                er10col5 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients lost to follow-up (female, 5-14 yrs)_HMIS 9.3") {
                                                er10col6 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients lost to follow-up (male, < 1 yrs)_HMIS 9.3") {
                                                er10col7 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients lost to follow-up (male, 1-4 yrs)_HMIS 9.3") {
                                                er10col8 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients lost to follow-up (male, 5-14 yrs)_HMIS 9.3") {
                                                er10col9 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients lost to follow-up (sex worker)_HMIS 9.3") {
                                                er10col10 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients lost to follow-up (people who inject drugs)_HMIS 9.3") {
                                                er10col11 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients lost to follow-up (MSM/TG)_HMIS 9.3") {
                                                er10col12 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients lost to follow-up (migrants)_HMIS 9.3") {
                                                er10col13 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients lost to follow-up (other risk groups)_HMIS 9.3") {
                                                er10col14 += parseInt(data3.rows[i][2]);
                                            }

                                            //row 17
                                            if (data3.rows[i][0] == "Patients stopped ART treatment (female)_HMIS 9.3") {
                                                er11col1 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients stopped ART treatment (male)_HMIS 9.3") {
                                                er11col2 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients stopped ART treatment (other sex)_HMIS 9.3") {
                                                er11col3 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients stopped ART treatment (female, < 1 yrs)_HMIS 9.3") {
                                                er11col4 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients stopped ART treatment (female, 1-4 yrs)_HMIS 9.3") {
                                                er11col5 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients stopped ART treatment (female, 5-14 yrs)_HMIS 9.3") {
                                                er11col6 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients stopped ART treatment (male, < 1 yrs)_HMIS 9.3") {
                                                er11col7 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients stopped ART treatment (male, 1-4 yrs)_HMIS 9.3") {
                                                er11col8 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients stopped ART treatment (male, 5-14 yrs)_HMIS 9.3") {
                                                er11col9 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients stopped ART treatment (sex worker)_HMIS 9.3") {
                                                er11col10 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients stopped ART treatment (people who inject drugs)_HMIS 9.3") {
                                                er11col11 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients stopped ART treatment (MSM/TG)_HMIS 9.3") {
                                                er11col12 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients stopped ART treatment (migrants)_HMIS 9.3") {
                                                er11col13 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients stopped ART treatment (other risk groups)_HMIS 9.3") {
                                                er11col14 += parseInt(data3.rows[i][2]);
                                            }

                                            

                                            //row 19
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (female)_HMIS 9.3") {
                                                er13col1 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (male)_HMIS 9.3") {
                                                er13col2 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (other sex)_HMIS 9.3") {
                                                er13col3 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (female, < 1 yrs)_HMIS 9.3") {
                                                er13col4 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (female, 1-4 yrs)_HMIS 9.3") {
                                                er13col5 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (female, 5-14 yrs)_HMIS 9.3") {
                                                er13col6 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (male, <1 yrs)_HMIS 9.3") {
                                                er13col7 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (male, 1-4 yrs)_HMIS 9.3") {
                                                er13col8 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (male, 5-14 yrs)_HMIS 9.3") {
                                                er13col9 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (sex worker)_HMIS 9.3") {
                                                er13col10 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (people who inject drugs)_HMIS 9.3") {
                                                er13col11 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "atients in 1st line regimen (MSM/TG)_HMIS 9.3") {
                                                er13col12 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (migrants)_HMIS 9.3") {
                                                er13col13 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (others)_HMIS 9.3") {
                                                er13col14 += parseInt(data3.rows[i][2]);
                                            }

                                            //row 20
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (substitution, female)_HMIS 9.3") {
                                                er14col1 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (substitution, male)_HMIS 9.3") {
                                                er14col2 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (substitution, other sex)_HMIS 9.3") {
                                                er14col3 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (substitution, female, < 1 yrs)_HMIS 9.3") {
                                                er14col4 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (substitution, female, 1-4 yrs)_HMIS 9.3") {
                                                er14col5 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (substitution, female, 5-14 yrs)_HMIS 9.3") {
                                                er14col6 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (substitution, male, < 1 yrs)_HMIS 9.3") {
                                                er14col7 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (substitution, male, 1-4 yrs)_HMIS 9.3") {
                                                er14col8 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (substitution, male, 5-14 yrs)_HMIS 9.3") {
                                                er14col9 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (substitution, sex worker)_HMIS 9.3") {
                                                er14col10 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (substitution, people who inject drugs)_HMIS 9.3") {
                                                er14col11 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (substitution, MSM/TG)_HMIS 9.3") {
                                                er14col12 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (substitution, migrants)_HMIS 9.3") {
                                                er14col13 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 1st line regimen (substitution, other risk groups)_HMIS 9.3") {
                                                er14col14 += parseInt(data3.rows[i][2]);
                                            }

                                            //row 21
                                            if (data3.rows[i][0] == "Patients in 2nd line regimen (switched, female)_HMIS 9.3") {
                                                er15col1 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 2nd line regimen (switched, male)_HMIS 9.3") {
                                                er15col2 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 2nd line regimen (switched, other sex)_HMIS 9.3") {
                                                er15col3 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 2nd line regimen (switched, female, <1 yrs)_HMIS 9.3") {
                                                er15col4 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 2nd line regimen (switched, female, 1-4 yrs)_HMIS 9.3") {
                                                er15col5 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 2nd line regimen (switched, female, 5-14 yrs)_HMIS 9.3") {
                                                er15col6 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 2nd line regimen (switched, male, <1 yrs)_HMIS 9.3") {
                                                er15col7 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 2nd line regimen (switched, male, 1-4 yrs)_HMIS 9.3") {
                                                er15col8 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 2nd line regimen (switched, male, 5-14 yrs)_HMIS 9.3") {
                                                er15col9 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 2nd line regimen (switched, sex worker)_HMIS 9.3") {
                                                er15col10 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 2nd line regimen (switched, people who inject drugs)_HMIS 9.3") {
                                                er15col11 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 2nd line regimen (switched, MSM/TG)_HMIS 9.3") {
                                                er15col12 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 2nd line regimen (switched, migrants)_HMIS 9.3") {
                                                er15col13 += parseInt(data3.rows[i][2]);
                                            }
                                            if (data3.rows[i][0] == "Patients in 2nd line regimen (switched, other risk groups)_HMIS 9.3") {
                                                er15col14 += parseInt(data3.rows[i][2]);
                                            }
                                        }



                                        //calculations of cummulicative values

                                        er1col1 = br1col1 + dr1col1;
                                        er1col2 = br1col2 + dr1col2;
                                        er1col3 = br1col3 + dr1col3;
                                        er1col4 = br1col4 + dr1col4;
                                        er1col5 = br1col5 + dr1col5;
                                        er1col6 = br1col6 + dr1col6;
                                        er1col7 = br1col7 + dr1col7;
                                        er1col8 = br1col8 + dr1col8;
                                        er1col9 = br1col9 + dr1col9;
                                        er1col10 = br1col10 + dr1col10;
                                        er1col11 = br1col11 + dr1col11;
                                        er1col12 = br1col12 + dr1col12;
                                        er1col13 = br1col13 + dr1col13;
                                        er1col14 = br1col14 + dr1col14;


                                        er4col1 = er1col1 - er2col1 - er3col1;
                                        er4col2 = er1col2 - er2col2 - er3col2;
                                        er4col3 = er1col3 - er2col3 - er3col3;
                                        er4col4 = er1col4 - er2col4 - er3col4;
                                        er4col5 = er1col5 - er2col5 - er3col5;
                                        er4col6 = er1col6 - er2col6 - er3col6;
                                        er4col7 = er1col7 - er2col7 - er3col7;
                                        er4col8 = er1col8 - er2col8 - er3col8;
                                        er4col9 = er1col9 - er2col9 - er3col9;
                                        er4col10 = er1col10 - er2col10 - er3col10;
                                        er4col11 = er1col11 - er2col11 - er3col11;
                                        er4col12 = er1col12 - er2col12 - er3col12;
                                        er4col13 = er1col13 - er2col13 - er3col13;
                                        er4col14 = er1col14 - er2col14 - er3col14;

                                        er6col1 = br2col1 + dr3col1;
                                        er6col2 = br2col2 + dr3col2;
                                        er6col3 = br2col3 + dr3col3;
                                        er6col4 = br2col4 + dr3col4;
                                        er6col5 = br2col5 + dr3col5;
                                        er6col6 = br2col6 + dr3col6;
                                        er6col7 = br2col7 + dr3col7;
                                        er6col8 = br2col8 + dr3col8;
                                        er6col9 = br2col9 + dr3col9;
                                        er6col10 = br2col10 + dr3col10;
                                        er6col11 = br2col11 + dr3col11;
                                        er6col12 = br2col12 + dr3col12;
                                        er6col13 = br2col13 + dr3col13;
                                        er6col14 = br2col14 + dr3col14;

                                        er8col1 = er3col1;
                                        er8col2 = er3col2;
                                        er8col3 = er3col3;
                                        er8col4 = er3col4;
                                        er8col5 = er3col5;
                                        er8col6 = er3col6;
                                        er8col7 = er3col7;
                                        er8col8 = er3col8;
                                        er8col9 = er3col9;
                                        er8col10 = er3col10;
                                        er8col11 = er3col11;
                                        er8col12 = er3col12;
                                        er8col13 = er3col13;
                                        er8col14 = er3col14;

                                        er12col1 = er8col1 + er9col1 + er10col1 + er11col1;
                                        er12col2 = er8col2 + er9col2 + er10col2 + er11col2;
                                        er12col3 = er8col3 + er9col3 + er10col3 + er11col3;
                                        er12col4 = er8col4 + er9col4 + er10col4 + er11col4;
                                        er12col5 = er8col5 + er9col5 + er10col5 + er11col5;
                                        er12col6 = er8col6 + er9col6 + er10col6 + er11col6;
                                        er12col7 = er8col7 + er9col7 + er10col7 + er11col7;
                                        er12col8 = er8col8 + er9col8 + er10col8 + er11col8;
                                        er12col9 = er8col9 + er9col9 + er10col9 + er11col9;
                                        er12col10 = er8col10 + er9col10 + er10col10 + er11col10;
                                        er12col11 = er8col11 + er9col11 + er10col11 + er11col11;
                                        er12col12 = er8col12 + er9col12 + er10col12 + er11col12;
                                        er12col13 = er8col13 + er9col13 + er10col13 + er11col13;
                                        er12col14 = er8col14 + er9col14 + er10col14 + er11col14;


                                        // mapping all values to table
                                        // row1
                                        document.getElementById('br1col1').innerHTML = br1col1;
                                        document.getElementById('br1col2').innerHTML = br1col2;
                                        document.getElementById('br1col3').innerHTML = br1col3;
                                        document.getElementById('br1col4').innerHTML = br1col4;
                                        document.getElementById('br1col5').innerHTML = br1col5;
                                        document.getElementById('br1col6').innerHTML = br1col6
                                        document.getElementById('br1col7').innerHTML = br1col7;
                                        document.getElementById('br1col8').innerHTML = br1col8;
                                        document.getElementById('br1col9').innerHTML = br1col9;
                                        document.getElementById('br1col10').innerHTML = br1col10;
                                        document.getElementById('br1col11').innerHTML = br1col11;
                                        document.getElementById('br1col12').innerHTML = br1col12;
                                        document.getElementById('br1col13').innerHTML = br1col13;
                                        document.getElementById('br1col14').innerHTML = br1col14;

                                        // row2
                                        document.getElementById('dr1col1').innerHTML = dr1col1;
                                        document.getElementById('dr1col2').innerHTML = dr1col2;
                                        document.getElementById('dr1col3').innerHTML = dr1col3;
                                        document.getElementById('dr1col4').innerHTML = dr1col4;
                                        document.getElementById('dr1col5').innerHTML = dr1col5;
                                        document.getElementById('dr1col6').innerHTML = dr1col6;
                                        document.getElementById('dr1col7').innerHTML = dr1col7;
                                        document.getElementById('dr1col8').innerHTML = dr1col8;
                                        document.getElementById('dr1col9').innerHTML = dr1col9;
                                        document.getElementById('dr1col10').innerHTML = dr1col10;
                                        document.getElementById('dr1col11').innerHTML = dr1col11;
                                        document.getElementById('dr1col12').innerHTML = dr1col12;
                                        document.getElementById('dr1col13').innerHTML = dr1col13;
                                        document.getElementById('dr1col14').innerHTML = dr1col14;

                                        // row4
                                        document.getElementById('er1col1').innerHTML = er1col1;
                                        document.getElementById('er1col2').innerHTML = er1col2;
                                        document.getElementById('er1col3').innerHTML = er1col3;
                                        document.getElementById('er1col4').innerHTML = er1col4;
                                        document.getElementById('er1col5').innerHTML = er1col5;
                                        document.getElementById('er1col6').innerHTML = er1col6;
                                        document.getElementById('er1col7').innerHTML = er1col7;
                                        document.getElementById('er1col8').innerHTML = er1col8;
                                        document.getElementById('er1col9').innerHTML = er1col9;
                                        document.getElementById('er1col10').innerHTML = er1col10;
                                        document.getElementById('er1col11').innerHTML = er1col11;
                                        document.getElementById('er1col12').innerHTML = er1col12;
                                        document.getElementById('er1col13').innerHTML = er1col13;
                                        document.getElementById('er1col14').innerHTML = er1col14;

                                        // row5
                                        document.getElementById('er2col1').innerHTML = er2col1;
                                        document.getElementById('er2col2').innerHTML = er2col2;
                                        document.getElementById('er2col3').innerHTML = er2col3;
                                        document.getElementById('er2col4').innerHTML = er2col4;
                                        document.getElementById('er2col5').innerHTML = er2col5;
                                        document.getElementById('er2col6').innerHTML = er2col6;
                                        document.getElementById('er2col7').innerHTML = er2col7;
                                        document.getElementById('er2col8').innerHTML = er2col8;
                                        document.getElementById('er2col9').innerHTML = er2col9;
                                        document.getElementById('er2col10').innerHTML = er2col10;
                                        document.getElementById('er2col11').innerHTML = er2col11;
                                        document.getElementById('er2col12').innerHTML = er2col12;
                                        document.getElementById('er2col13').innerHTML = er2col13;
                                        document.getElementById('er2col14').innerHTML = er2col14;

                                        // row6
                                        document.getElementById('er3col1').innerHTML = er3col1;
                                        document.getElementById('er3col2').innerHTML = er3col2;
                                        document.getElementById('er3col3').innerHTML = er3col3;
                                        document.getElementById('er3col4').innerHTML = er3col4;
                                        document.getElementById('er3col5').innerHTML = er3col5;
                                        document.getElementById('er3col6').innerHTML = er3col6;
                                        document.getElementById('er3col7').innerHTML = er3col7;
                                        document.getElementById('er3col8').innerHTML = er3col8;
                                        document.getElementById('er3col9').innerHTML = er3col9;
                                        document.getElementById('er3col10').innerHTML = er3col10;
                                        document.getElementById('er3col11').innerHTML = er3col11;
                                        document.getElementById('er3col12').innerHTML = er3col12;
                                        document.getElementById('er3col13').innerHTML = er3col13;
                                        document.getElementById('er3col14').innerHTML = er3col14;

                                        // row7
                                        document.getElementById('er4col1').innerHTML = er4col1;
                                        document.getElementById('er4col2').innerHTML = er4col2;
                                        document.getElementById('er4col3').innerHTML = er4col3;
                                        document.getElementById('er4col4').innerHTML = er4col4;
                                        document.getElementById('er4col5').innerHTML = er4col5;
                                        document.getElementById('er4col6').innerHTML = er4col6;
                                        document.getElementById('er4col7').innerHTML = er4col7;
                                        document.getElementById('er4col8').innerHTML = er4col8;
                                        document.getElementById('er4col9').innerHTML = er4col9;
                                        document.getElementById('er4col10').innerHTML = er4col10;
                                        document.getElementById('er4col11').innerHTML = er4col11;
                                        document.getElementById('er4col12').innerHTML = er4col12;
                                        document.getElementById('er4col13').innerHTML = er4col13;
                                        document.getElementById('er4col14').innerHTML = er4col14;

                                        // row 9
                                        document.getElementById('br2col1').innerHTML = br2col1;
                                        document.getElementById('br2col2').innerHTML = br2col2;
                                        document.getElementById('br2col3').innerHTML = br2col3;
                                        document.getElementById('br2col4').innerHTML = br2col4;
                                        document.getElementById('br2col5').innerHTML = br2col5;
                                        document.getElementById('br2col6').innerHTML = br2col6
                                        document.getElementById('br2col7').innerHTML = br2col7;
                                        document.getElementById('br2col8').innerHTML = br2col8;
                                        document.getElementById('br2col9').innerHTML = br2col9;
                                        document.getElementById('br2col10').innerHTML = br2col10;
                                        document.getElementById('br2col11').innerHTML = br2col11;
                                        document.getElementById('br2col12').innerHTML = br2col12;
                                        document.getElementById('br2col13').innerHTML = br2col13;
                                        document.getElementById('br2col14').innerHTML = br2col14;

                                        // row 10
                                        document.getElementById('dr3col1').innerHTML = dr3col1;
                                        document.getElementById('dr3col2').innerHTML = dr3col2;
                                        document.getElementById('dr3col3').innerHTML = dr3col3;
                                        document.getElementById('dr3col4').innerHTML = dr3col4;
                                        document.getElementById('dr3col5').innerHTML = dr3col5;
                                        document.getElementById('dr3col6').innerHTML = dr3col6;
                                        document.getElementById('dr3col7').innerHTML = dr3col7;
                                        document.getElementById('dr3col8').innerHTML = dr3col8;
                                        document.getElementById('dr3col9').innerHTML = dr3col9;
                                        document.getElementById('dr3col10').innerHTML = dr3col10;
                                        document.getElementById('dr3col11').innerHTML = dr3col11;
                                        document.getElementById('dr3col12').innerHTML = dr3col12;
                                        document.getElementById('dr3col13').innerHTML = dr3col13;
                                        document.getElementById('dr3col14').innerHTML = dr3col14;

                                        // row 12
                                        document.getElementById('er6col1').innerHTML = er6col1;
                                        document.getElementById('er6col2').innerHTML = er6col2;
                                        document.getElementById('er6col3').innerHTML = er6col3;
                                        document.getElementById('er6col4').innerHTML = er6col4;
                                        document.getElementById('er6col5').innerHTML = er6col5;
                                        document.getElementById('er6col6').innerHTML = er6col6;
                                        document.getElementById('er6col7').innerHTML = er6col7;
                                        document.getElementById('er6col8').innerHTML = er6col8;
                                        document.getElementById('er6col9').innerHTML = er6col9;
                                        document.getElementById('er6col10').innerHTML = er6col10;
                                        document.getElementById('er6col11').innerHTML = er6col11;
                                        document.getElementById('er6col12').innerHTML = er6col12;
                                        document.getElementById('er6col13').innerHTML = er6col13;
                                        document.getElementById('er6col14').innerHTML = er6col14;

                                        // row 14
                                        document.getElementById('er8col1').innerHTML = er8col1;
                                        document.getElementById('er8col2').innerHTML = er8col2;
                                        document.getElementById('er8col3').innerHTML = er8col3;
                                        document.getElementById('er8col4').innerHTML = er8col4;
                                        document.getElementById('er8col5').innerHTML = er8col5;
                                        document.getElementById('er8col6').innerHTML = er8col6;
                                        document.getElementById('er8col7').innerHTML = er8col7;
                                        document.getElementById('er8col8').innerHTML = er8col8;
                                        document.getElementById('er8col9').innerHTML = er8col9;
                                        document.getElementById('er8col10').innerHTML = er8col10;
                                        document.getElementById('er8col11').innerHTML = er8col11;
                                        document.getElementById('er8col12').innerHTML = er8col12;
                                        document.getElementById('er8col13').innerHTML = er8col13;
                                        document.getElementById('er8col14').innerHTML = er8col14;

                                        // row 15
                                        document.getElementById('er9col1').innerHTML = er9col1;
                                        document.getElementById('er9col2').innerHTML = er9col2;
                                        document.getElementById('er9col3').innerHTML = er9col3;
                                        document.getElementById('er9col4').innerHTML = er9col4;
                                        document.getElementById('er9col5').innerHTML = er9col5;
                                        document.getElementById('er9col6').innerHTML = er9col6;
                                        document.getElementById('er9col7').innerHTML = er9col7;
                                        document.getElementById('er9col8').innerHTML = er9col8;
                                        document.getElementById('er9col9').innerHTML = er9col9;
                                        document.getElementById('er9col10').innerHTML = er9col10;
                                        document.getElementById('er9col11').innerHTML = er9col11;
                                        document.getElementById('er9col12').innerHTML = er9col12;
                                        document.getElementById('er9col13').innerHTML = er9col13;
                                        document.getElementById('er9col14').innerHTML = er9col14;

                                        // row 16
                                        document.getElementById('er10col1').innerHTML = er10col1;
                                        document.getElementById('er10col2').innerHTML = er10col2;
                                        document.getElementById('er10col3').innerHTML = er10col3;
                                        document.getElementById('er10col4').innerHTML = er10col4;
                                        document.getElementById('er10col5').innerHTML = er10col5;
                                        document.getElementById('er10col6').innerHTML = er10col6;
                                        document.getElementById('er10col7').innerHTML = er10col7;
                                        document.getElementById('er10col8').innerHTML = er10col8;
                                        document.getElementById('er10col9').innerHTML = er10col9;
                                        document.getElementById('er10col10').innerHTML = er10col10;
                                        document.getElementById('er10col11').innerHTML = er10col11;
                                        document.getElementById('er10col12').innerHTML = er10col12;
                                        document.getElementById('er10col13').innerHTML = er10col13;
                                        document.getElementById('er10col14').innerHTML = er10col14;

                                        // row 17
                                        document.getElementById('er11col1').innerHTML = er11col1;
                                        document.getElementById('er11col2').innerHTML = er11col2;
                                        document.getElementById('er11col3').innerHTML = er11col3;
                                        document.getElementById('er11col4').innerHTML = er11col4;
                                        document.getElementById('er11col5').innerHTML = er11col5;
                                        document.getElementById('er11col6').innerHTML = er11col6;
                                        document.getElementById('er11col7').innerHTML = er11col7;
                                        document.getElementById('er11col8').innerHTML = er11col8;
                                        document.getElementById('er11col9').innerHTML = er11col9;
                                        document.getElementById('er11col10').innerHTML = er11col10;
                                        document.getElementById('er11col11').innerHTML = er11col11;
                                        document.getElementById('er11col12').innerHTML = er11col12;
                                        document.getElementById('er11col13').innerHTML = er11col13;
                                        document.getElementById('er11col14').innerHTML = er11col14;

                                        // row 18
                                        document.getElementById('er12col1').innerHTML = er12col1;
                                        document.getElementById('er12col2').innerHTML = er12col2;
                                        document.getElementById('er12col3').innerHTML = er12col3;
                                        document.getElementById('er12col4').innerHTML = er12col4;
                                        document.getElementById('er12col5').innerHTML = er12col5;
                                        document.getElementById('er12col6').innerHTML = er12col6;
                                        document.getElementById('er12col7').innerHTML = er12col7;
                                        document.getElementById('er12col8').innerHTML = er12col8;
                                        document.getElementById('er12col9').innerHTML = er12col9;
                                        document.getElementById('er12col10').innerHTML = er12col10;
                                        document.getElementById('er12col11').innerHTML = er12col11;
                                        document.getElementById('er12col12').innerHTML = er12col12;
                                        document.getElementById('er12col13').innerHTML = er12col13;
                                        document.getElementById('er12col14').innerHTML = er12col14;

                                        // row 19
                                        document.getElementById('er13col1').innerHTML = er13col1;
                                        document.getElementById('er13col2').innerHTML = er13col2;
                                        document.getElementById('er13col3').innerHTML = er13col3;
                                        document.getElementById('er13col4').innerHTML = er13col4;
                                        document.getElementById('er13col5').innerHTML = er13col5;
                                        document.getElementById('er13col6').innerHTML = er13col6;
                                        document.getElementById('er13col7').innerHTML = er13col7;
                                        document.getElementById('er13col8').innerHTML = er13col8;
                                        document.getElementById('er13col9').innerHTML = er13col9;
                                        document.getElementById('er13col10').innerHTML = er13col10;
                                        document.getElementById('er13col11').innerHTML = er13col11;
                                        document.getElementById('er13col12').innerHTML = er13col12;
                                        document.getElementById('er13col13').innerHTML = er13col13;
                                        document.getElementById('er13col14').innerHTML = er13col14;

                                        // row 20
                                        document.getElementById('er14col1').innerHTML = er14col1;
                                        document.getElementById('er14col2').innerHTML = er14col2;
                                        document.getElementById('er14col3').innerHTML = er14col3;
                                        document.getElementById('er14col4').innerHTML = er14col4;
                                        document.getElementById('er14col5').innerHTML = er14col5;
                                        document.getElementById('er14col6').innerHTML = er14col6;
                                        document.getElementById('er14col7').innerHTML = er14col7;
                                        document.getElementById('er14col8').innerHTML = er14col8;
                                        document.getElementById('er14col9').innerHTML = er14col9;
                                        document.getElementById('er14col10').innerHTML = er14col10;
                                        document.getElementById('er14col11').innerHTML = er14col11;
                                        document.getElementById('er14col12').innerHTML = er14col12;
                                        document.getElementById('er14col13').innerHTML = er14col13;
                                        document.getElementById('er14col14').innerHTML = er14col14;

                                        // row 21
                                        document.getElementById('er15col1').innerHTML = er15col1;
                                        document.getElementById('er15col2').innerHTML = er15col2;
                                        document.getElementById('er15col3').innerHTML = er15col3;
                                        document.getElementById('er15col4').innerHTML = er15col4;
                                        document.getElementById('er15col5').innerHTML = er15col5;
                                        document.getElementById('er15col6').innerHTML = er15col6;
                                        document.getElementById('er15col7').innerHTML = er15col7;
                                        document.getElementById('er15col8').innerHTML = er15col8;
                                        document.getElementById('er15col9').innerHTML = er15col9;
                                        document.getElementById('er15col10').innerHTML = er15col10;
                                        document.getElementById('er15col11').innerHTML = er15col11;
                                        document.getElementById('er15col12').innerHTML = er15col12;
                                        document.getElementById('er15col13').innerHTML = er15col13;
                                        document.getElementById('er15col14').innerHTML = er15col14;

                                    }
                                });
                            }
                        });
                    }
                });




            };
            if (ouLevel == 5) {
                printData(ou);
            }
            else {
                alert("wrong selection!");
            }
        };
    </script>
    <style>
        .heading td {

            color: white;
            text-align: center;
            border: none;
        }

        #heading {
            text-align: center;
        }


        table {
            border-collapse: collapse;
        }

        td {
            border: 1px solid black;
            height: 30px;
            width: 200px;
            text-align: center;
            font-weight: bold;

        }

        .noBorder {
            border: none;
        }

        table thead {
            background: lightgray;
        }

        #export {
            margin-left: 90px;
        }
    </style>
</head>

<body>

    <div class="body">
        <button id="export">Export to Excel</button>
        <br>

        <center> Start Date :
            <input type="date" id="start" required> End Date :
            <input type="date" id="end" required>
            <br>
            <br>
            <button onClick="submit()" id="tap">Submit</button>
        </center>
        <br>
        <br>
        <table class="table table-bordered reporttable" id="report_table" border='1'>
            <thead>
                <!--tr class="heading" bgcolor="#1D9FDF" border="none" text-align="center">
                        <td colspan="3" rowspan="3" border="none" text-align="center"><img src="http://apps.hispindia.org/drilp/dhis-web-commons/security/drliplogo_reports.jpg"" width="90%" height="400%"></td>
                        <td colspan="11" rowspan="1" border="none" text-align="center">
                            <p style="font-size:16px;">Earthquake Emergency Assistance Project (EEAP)</p>
                        </td>
                        <td colspan="3" rowspan="3" border="none" text-align="center"></td>
                    </tr-->
                <tr class="heading" bgcolor="#1D9FDF">
                    <td colspan="30" rowspan="1" border="none" text-align="center">
                        <p style="font-size:20px;">12. HIV/AIDS Program</p>
                    </td>

                </tr>
                <tr class="heading" bgcolor="#1D9FDF" border="none" style="text-align:left">

                    <td style="border:1px solid black;text-align:left" colspan="5" width="125">Name of the Facility: :-&nbsp;
                        <span id="ouname"></span>
                    </td>
                    <td style="border:1px solid black;text-align:left" colspan="3" width="125">Period from :-&nbsp;
                        <span id="periodFrom"></span>
                    </td>
                    <td style="border:1px solid black;text-align:left" colspan="3" width="125">Period to :-&nbsp;
                        <span id="periodTo"></span>
                    </td>
                    <td style="border:1px solid black;text-align:left" colspan="6" width="125">Month/Year: :-&nbsp;
                        <span id="timePeriod"></span>
                    </td>
                </tr>


                <tr height="80">
                    <!--td rowspan="4">Testing and Counseling with Result</td-->
                    <td colspan="2" rowspan="3">Anteretroviral Tretment: Status of HIV CareAge Group</td>
                    <td rowspan="3">of This Month</td>
                    <td colspan="9" style="width:188px;">Age Group in Years</td>
                    <td colspan="5" style="width:188px;">By Target population</td>


                </tr>
                <tr height="30">
                    <td colspan="3" style="width:63px;">Adult</td>
                    <td colspan="3" style="width:63px;">Child (Female)</td>
                    <td colspan="3" style="width:63px;">Child (Male)</td>
                    <td rowspan="2" style="width:63px;">FSW</td>
                    <td rowspan="2" style="width:63px;">PWID</td>
                    <td rowspan="2" style="width:63px;">MSM</td>
                    <td rowspan="2" style="width:63px;">Mi- grant</td>
                    <td rowspan="2" style="width:63px;">others</td>

                </tr>

                <tr height="20">

                    <td rowspan="1" style="width:63px;">F</td>
                    <td rowspan="1" style="width:63px;">M</td>
                    <td rowspan="1" style="width:63px;">TG</td>
                    <td rowspan="1" style="width:63px;">
                        <1</td>
                            <td rowspan="1" style="width:63px;">1-4</td>
                            <td rowspan="1" style="width:63px;">5-14</td>
                            <td rowspan="1" style="width:63px;">
                                <1</td>
                                    <td rowspan="1" style="width:63px;">1-4</td>
                                    <td rowspan="1" style="width:63px;">5-14</td>

                </tr>




                <tr height="60">
                    <td rowspan="3">Enrollment in HIV Care</td>
                    <td colspan="1">Cumulative no of Patients ever enrolled (1a)</td>
                    <td colspan="1">Beginning</td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br1col1"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br1col2"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br1col3"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br1col4"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br1col5"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br1col6"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br1col7"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br1col8"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br1col9"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br1col10"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br1col11"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br1col12"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br1col13"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br1col14"></td>



                </tr>

                <tr height="60">
                    <td colspan="1">New patients enrolled in HIV care (1b)</td>
                    <td colspan="1">During</td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr1col1"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr1col2"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr1col3"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr1col4"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr1col5"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr1col6"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr1col7"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr1col8"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr1col9"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr1col10"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr1col11"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr1col12"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr1col13"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr1col14"></td>


                </tr>

                <tr height="60" style="background-color:red">

                    <td colspan="1">Number of patients transferred in (1c)</td>
                    <td colspan="1">During</td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>

                </tr>
                <tr height="60">
                    <td colspan="2">Patients ever enrolled in HIV Care at the end of this month(1d)= 1a+1b+1c</td>
                    <td colspan="1">End</td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er1col1"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er1col2"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er1col3"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er1col4"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er1col5"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er1col6"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er1col7"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er1col8"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er1col9"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er1col10"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er1col11"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er1col12"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er1col13"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er1col14"></td>


                </tr>
                <tr height="60">
                    <td colspan="2">Number of patients transferred out (Cumulative) (1e)</td>
                    <td colspan="1">End</td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er2col1"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er2col2"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er2col3"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er2col4"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er2col5"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er2col6"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er2col7"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er2col8"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er2col9"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er2col10"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er2col11"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er2col12"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er2col13"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er2col14"></td>


                </tr>
                <tr height="60">
                    <td colspan="2">Number of patients death reported (Cumulative) (1f)</td>
                    <td colspan="1">End</td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er3col1"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er3col2"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er3col3"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er3col4"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er3col5"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er3col6"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er3col7"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er3col8"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er3col9"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er3col10"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er3col11"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er3col12"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er3col13"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er3col14"></td>


                </tr>
                <tr height="60">
                    <td colspan="2">Total no of patients currently on HIV care (1)= 1d-1e-1f</td>
                    <td colspan="1">End</td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er4col1"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er4col2"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er4col3"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er4col4"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er4col5"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er4col6"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er4col7"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er4col8"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er4col9"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er4col10"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er4col11"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er4col12"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er4col13"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er4col14"></td>


                </tr>
                <tr height="60">
                    <td colspan="2">Patients medically eligible for ART but have not started (2)</td>
                    <td colspan="1">End</td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er5col1"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er5col2"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er5col3"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er5col4"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er5col5"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er5col6"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er5col7"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er5col8"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er5col9"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er5col10"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er5col11"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er5col12"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er5col13"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er5col14"></td>


                </tr>

                <tr height="60">
                    <td rowspan="3">Enrollment on ART</td>
                    <td colspan="1">Patients ever started ART at the end of last month (3)</td>
                    <td colspan="1">Beginning</td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br2col1"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br2col2"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br2col3"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br2col4"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br2col5"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br2col6"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br2col7"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br2col8"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br2col9"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br2col10"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br2col11"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br2col12"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br2col13"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="br2col14"></td>



                </tr>

                <tr height="60">
                    <td colspan="1">New patients started ART (3b)</td>
                    <td colspan="1">During</td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr3col1"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr3col2"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr3col3"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr3col4"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr3col5"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr3col6"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr3col7"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr3col8"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr3col9"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr3col10"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr3col11"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr3col12"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr3col13"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="dr3col14"></td>


                </tr>

                <tr height="60" style="background-color:red">

                    <td colspan="1">Patients on ART transferred in (3c)</td>
                    <td colspan="1">During</td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>
                    <td colspan="1"></td>

                </tr>

                <tr height="60">
                    <td colspan="2">Patients ever started ART at end of this month(3)= 3a+3b+3</td>
                    <td colspan="1">End</td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er6col1"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er6col2"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er6col3"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er6col4"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er6col5"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er6col6"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er6col7"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er6col8"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er6col9"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er6col10"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er6col11"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er6col12"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er6col13"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er6col14"></td>


                </tr>

                <tr height="60">
                    <td rowspan="5">Deduction</td>
                    <td colspan="1" style="background-color:red">Total patients on ART transfer-out (cumulative) (4a)</td>
                    <td colspan="1" style="background-color:red">End</td>
                    <td colspan="1" style="background-color:red" class="mapped" id="er7col1"></td>
                    <td colspan="1" style="background-color:red" class="mapped" id="er7col2"></td>
                    <td colspan="1" style="background-color:red" class="mapped" id="er7col3"></td>
                    <td colspan="1" style="background-color:red" class="mapped" id="er7col4"></td>
                    <td colspan="1" style="background-color:red" class="mapped" id="er7col5"></td>
                    <td colspan="1" style="background-color:red" class="mapped" id="er7col6"></td>
                    <td colspan="1" style="background-color:red" class="mapped" id="er7col7"></td>
                    <td colspan="1" style="background-color:red" class="mapped" id="er7col8"></td>
                    <td colspan="1" style="background-color:red" class="mapped" id="er7col9"></td>
                    <td colspan="1" style="background-color:red" class="mapped" id="er7col10"></td>
                    <td colspan="1" style="background-color:red" class="mapped" id="er7col11"></td>
                    <td colspan="1" style="background-color:red" class="mapped" id="er7col12"></td>
                    <td colspan="1" style="background-color:red" class="mapped" id="er7col13"></td>
                    <td colspan="1" style="background-color:red" class="mapped" id="er7col14"></td>



                </tr>

                <tr height="60">
                    <td colspan="1">Total deaths reported (cumulative) (4b)</td>
                    <td colspan="1">End</td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er8col1"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er8col2"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er8col3"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er8col4"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er8col5"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er8col6"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er8col7"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er8col8"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er8col9"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er8col10"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er8col11"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er8col12"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er8col13"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er8col14"></td>


                </tr>

                <tr height="60">

                    <td colspan="1">Total patients missing (MIS) (4c)</td>
                    <td colspan="1">End</td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er9col1"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er9col2"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er9col3"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er9col4"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er9col5"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er9col6"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er9col7"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er9col8"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er9col9"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er9col10"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er9col11"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er9col12"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er9col13"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er9col14"></td>

                </tr>

                <tr height="60">

                    <td colspan="1">Total patients lost to follow-up (LFU) (4d)</td>
                    <td colspan="1">End</td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er10col1"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er10col2"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er10col3"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er10col4"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er10col5"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er10col6"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er10col7"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er10col8"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er10col9"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er10col10"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er10col11"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er10col12"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er10col13"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er10col14"></td>

                </tr>

                <tr height="60">

                    <td colspan="1">Total patients stopping (ST) ART (4e)</td>
                    <td colspan="1">End</td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er11col1"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er11col2"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er11col3"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er11col4"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er11col5"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er11col6"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er11col7"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er11col8"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er11col9"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er11col10"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er11col11"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er11col12"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er11col13"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er11col14"></td>

                </tr>

                <tr height="60">
                    <td colspan="2">Total number of clients currently on ART (4)=(3)-(4a+4b+4c+4d+4e)</td>
                    <td colspan="1">End</td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er12col1"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er12col2"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er12col3"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er12col4"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er12col5"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er12col6"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er12col7"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er12col8"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er12col9"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er12col10"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er12col11"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er12col12"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er12col13"></td>
                    <td colspan="1" style="background-color:green" class="mapped" id="er12col14"></td>


                </tr>

                <tr height="60">
                    <td rowspan="3">Out of them</td>
                    <td colspan="1">Patients in original 1st line regimen(4.1)</td>
                    <td colspan="1">End</td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er13col1"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er13col2"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er13col3"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er13col4"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er13col5"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er13col6"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er13col7"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er13col8"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er13col9"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er13col10"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er13col11"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er13col12"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er13col13"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er13col14"></td>



                </tr>

                <tr height="60">
                    <td colspan="1">Patients in substituted 1st line regimen(4.2)</td>
                    <td colspan="1">End</td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er14col1"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er14col2"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er14col3"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er14col4"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er14col5"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er14col6"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er14col7"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er14col8"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er14col9"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er14col10"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er14col11"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er14col12"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er14col13"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er14col14"></td>


                </tr>

                <tr height="60">

                    <td colspan="1">Patients switched on to 2nd line regimen(4.3)</td>
                    <td colspan="1">End</td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er15col1"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er15col2"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er15col3"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er15col4"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er15col5"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er15col6"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er15col7"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er15col8"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er15col9"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er15col10"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er15col11"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er15col12"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er15col13"></td>
                    <td colspan="1" style="background-color:white" class="mapped" id="er15col14"></td>

                </tr>

                <tr height="60" style="background-color:red">
                    <td colspan="2">Total MIS/LFU/ST patients restart ART this month (5)</td>
                    <td colspan="1">During</td>
                    <td colspan="1" class="mapped" id="dr5col1"></td>
                    <td colspan="1" class="mapped" id="dr5col2"></td>
                    <td colspan="1" class="mapped" id="dr5col3"></td>
                    <td colspan="1" class="mapped" id="dr5col4"></td>
                    <td colspan="1" class="mapped" id="dr5col5"></td>
                    <td colspan="1" class="mapped" id="dr5col6"></td>
                    <td colspan="1" class="mapped" id="dr5col7"></td>
                    <td colspan="1" class="mapped" id="dr5col8"></td>
                    <td colspan="1" class="mapped" id="dr5col9"></td>
                    <td colspan="1" class="mapped" id="dr5col10"></td>
                    <td colspan="1" class="mapped" id="dr5col11"></td>
                    <td colspan="1" class="mapped" id="dr5col12"></td>
                    <td colspan="1" class="mapped" id="dr5col13"></td>
                    <td colspan="1" class="mapped" id="dr5col14"></td>


                </tr>


            </thead>
        </table>

    </div>
</body>

</html>